package cn.edu.dao;

import cn.edu.domain.All;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Davey chan
 */
@Mapper
public interface dep_InfomationDao {
//    教务处获取年度考核 优良合格的数量
        @Select("select count(*) from annual_examination where checkResult like '优'")
        int GetExcellent();
            @Select("select count(*) from annual_examination where checkResult like '良'" )
        int GetGood();

            @Select("select count(*) from annual_examination where checkResult like '合格'")
        int GetNormal();
//    教师工作部获得下面的数量
    //   获得论文的数量
    @Select("select count(*) from thesis")
    int GetthesisNum();
    //    获得专利的数量
    @Select("select count(*) from patent")
    int GetPatentNum();
    //获得著作的数量
    @Select("select count(*) from opus")
    int GetOpsNum();
    //    科研部门获取科研项目，科研获奖总数
    //获得科研项目数的数量
    @Select("select count(*) from research_project")
    int Getresearch_projectNum();
    @Select("select count(*) from award")
    int GetAward();
//    教授的数量
@Select("select count(*) from teacher where title='教授'")
int GetprofessorNum();
//    副教授的数量
@Select("select count(*) from teacher where title='副教授'")
int GetAsprofessorNum();
//    讲师的数量
@Select("select count(*) from teacher where title='讲师'")
int GetLecturerNum();
    //    信息页面的分页查询
    List<All> Infoselect(@Param("begin") int begin, @Param("size")int size,@Param("t") All t);
    int selectTotalCountByCondition(All t);
}
